IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tr_ProjectAlertEmails_Del]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tr_ProjectAlertEmails_Del]
GO

CREATE PROCEDURE [dbo].[tr_ProjectAlertEmails_Del]
	@ProjectAlertEmailId UNIQUEIDENTIFIER
AS

DELETE FROM tr_ProjectAlertEmail WHERE ProjectAlertEmailId = @ProjectAlertEmailId